package vn.student.database;

public class DBComman
{
    public static final String DATABASENAME="n4s.db";
    
    public static final String TABLE_THONGBAO="thongtin";
    public static final String TABLE_CANHAN="canhan";
    
    public static final String THONGBAO_IDMSG="idmsg";
    public static final String THONGBAO_SENTTIME="senttime";
    public static final String THONGBAO_RECEIVEDTIME="receivedtime";
    public static final String THONGBAO_MESSAGE="message";
    public static final String THONGBAO_IDSHARED="idshared";
    
    public static final int IDMSG_ID=1;
    public static final int SENTTIME_ID=2;
    public static final int RECEIVED_ID=3;
    public static final int MESSAGE_ID=4;
    public static final int IDSHARED_ID=5;
    
    public static final String ID="_id";
    public static final String TITLE="titile";
    public static final String TIME="time";
    public static final String CONTENT="content";
    public static final String AUDIO="audio";
    public static final String ENABLE="enable";
    
    public static final String IDMSG="idmsg";
    public static final String SENTTIME="senttime";
    public static final String RECEIVEDTIME="receivedtime";
    public static final String IDSHARED="idshared";
	    
   
    
    
    public static final String SQL_GETALL_THONGBAO="select * from "+TABLE_THONGBAO;
}
